Install MariaDB
2014/06/06 |
Install MariaDB to configure database server.
|
|
[1] | Install MariaDB. |
root@www:~#
apt-get -y install mariadb-server-5.5 # set MariaDB's root password +-------------------+ Configuring mariadb-server-5.5 +--------------------+ | While not mandatory, it is highly recommended that you set a password | | for the MariaDB administrative "root" user. | | | | If this field is left blank, the password will not be changed. | | | | New password for the MariaDB "root" user: | | | | ********_______________________________________________________________ | | | | <Ok> | | | +-------------------------------------------------------------------------+ # connect to MariaDB root@www:~# mysql -u root -p Enter password: # MariaDB root password Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 36 Server version: 5.5.44-MariaDB-1ubuntu0.14.04.1 (Ubuntu) Copyright (c) 2000, 2015, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. # try to display user info MariaDB [(none)]> select user,host,password from mysql.user; +------------------+-----------+-------------------------------------------+ | user | host | password | +------------------+-----------+-------------------------------------------+ | root | localhost | *247xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | | root | www | *247xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | | root | 127.0.0.1 | *247xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | | root | ::1 | *247xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | | debian-sys-maint | localhost | *247xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx | +------------------+-----------+-------------------------------------------+ 5 rows in set (0.00 sec)MariaDB [(none)]> exit Bye |